<%@ page import="java.sql.*,studentportal.*"%>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Student Information</title>
</head>

<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>
<table border="0" width="100%">
  <tr>
    <td width="33%">
      <p align="center"><a href="CorporatesStudentsList.jsp">Student Information</a></td>
    <td width="33%">
      <p align="center"><a href="Notifications.jsp">Notifications</a></td>
    <td width="34%">
      <p align="center"><a href="Home.html">Home</a></td>
  </tr>
</table>
<p align="center">&nbsp;</p>
<form method="POST" action="./NotificationServlet">
   
  <div align="center">
    <center>
  <table border="1" width="86%" bordercolor="#0000FF">
    <tr>
      <td width="100%" colspan="2">
        <p align="center"><font size="4" color="blue"><b>Notification Information<b></font></td>
    </tr>
    </center>
    <tr>
      <td width="100%" colspan="2">
        <p align="center">Notification ID:
        <select size="1" name="nid" tabindex="1" style="width:144px">
		<%
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					ResultSet rs=st.executeQuery("select * from notification_master");
					int id=1000;
					String str1=null,str2=null;
					while(rs.next()) {
					str1=rs.getString(1);
					str2=str1.substring(4);
					id=Integer.parseInt(str2);
					id++;
					}
						con.close();
						st.close();
						//rs.close();
		%>
		<option><%="NOTI"+id%></option>
        </select> &nbsp;&nbsp;</td>
    </tr>
    <tr>
      <td width="50%">
        Advertisement Date:<input type="text" name="advdate" size="20" tabindex="2"><font color="red"><b>* YYYY-MM-DD *</b></font></td>
      <td width="50%">
        Last Date:<input type="text" name="advldate" size="20" tabindex="3"><font color="red"><b>* YYYY-MM-DD *</b></font></td>
  </tr>
<!--  	<tr width="100%"><td colspan="2"><font color="red"><center><b>* YYYY-MM-DD *</b></center></font></td></tr>
		<center>
 -->    <tr>
     <td width="100%" colspan="2">
        <p align="center"><textarea rows="8" name="Note" cols="61" tabindex="4">Write notification description here</textarea></td>
    </tr>
    <tr>
      <td width="100%" colspan="2">
        <p align="center"><input type="submit" value="Send" name="action" tabindex="8"></td>
    </tr>
  </table>
    </center>
  </div>
  <p align="center">&nbsp;</p>
</form>

</body>

</html>
